MSU Remote Sensing & GIS
FIELD DEFINITION LIST FOR Wells_ Hydraulic_ Properties shape file
WELLOGIC
FIELDS
FIELD Description
WELLID Wellogic ID number (unique identifying number, first 2
digits represent county number)
IMPORT_ID Former
Wellkey number
COUNTY
TOWNSHIP
TOWN_RANGE
SECTION
OWNER_NAME
WELL_ADDR
WELL_DEPTH
WELL_TYPE Type
of well
*OTH = Other
HEATP = Heat pump
HOSHLD = Household
IRRI = Irrigation
TESTW = Test well
TY1PU = Type I public
TY2PU = Type II public
TY3PU = Type III public
WSSN
Water Supply Serial Number, only if public well
WELL_NUM
Individual well number/name, only if public well
DRILLER_ID State
of
CONST_DATE
CASE_TYPE Well
Casing Type
*OTH = Other
*U =
Unknown
CLTC = Clay Tile Crock
PVCPLA
= PVC Plastic
STEBLA
= Steel-black
STEGAL = Steel-Galvanized
CASE_DIA Well
Casing Diameter (in inches)
CASE_DEPTH Depth
of Casing (in feet)
SCREEN_FRM Depth
where the screen starts (in feet)
SCREEN_TO Depth
where the screen ends (in feet)
SWL Static
Water Level (in feet)
TEST_DEPTH Depth
of drawdown when the well was developed (in feet)
TEST_HOURS Duration
of pumping when the well was developed (in hours)
TEST_RATE Rate
of water flow when the well was developed (in Gallons per Minute)
TEST_METHD Method
used to develop the well
*U = Unknown
*OTH = Other
AIR = Air
BAIL = Bailer
PLUGR = Plunger
TSTPUM
= Test Pump
PMP_CPCITY Capacity
of the pump installed in the well (in Gallons per Minute)
ADD
DEM ELEVATION FIELDS
FIELD Description
DEPTH_FLAG [Data Problem Flag]
1 Well Depth = 0
2 Well_Depth < 25’ or Well_Depth > 1000’
ELEV_DEM Surface Elevation (in feet) from the MapImage USGS 30-meter DEM file
SWL_FLAG [Data Problem Flag]
1 SWL = 0
2 SWL > Well_Depth
3 SWL > 900’
CREATE
ROCK & DRIFT WELL FIELDS
FIELD Description
AQ_CODE [Data
Problem Flag]
N No Lithology Record
B Blank (null aqtype)
D Drift Well
R Rock Well
U Unknown Lithology
AQ_FLAG [Data Problem Flag] (must contain a Rock stratum)
N No lithology record
D Depth Condition (Well Depth <= Top of Rock)
AQ_CODE is set to “D”
L Lithology Problem (Drift under Rock)
S Screen Condition (Screen Depth > 0 and Screen Depth <= Well Depth)
AQ_CODE is set to “D”
PCT_AQ Percent AQ within well log
PCT_AQ_D Percent AQ within Drift strata
PCT_AQ_R Percent AQ within Rock strata
PCT_MAQ Percent MAQ within well
PCT_MAQ_D Percent MAQ within Drift strata
PCT_MAQ_R Percent MAQ within Rock strata
PCT_FLAG ? Bad Strata Thickness (strataDepth - strataThickness) <> prevDepth
> ((aqFeet / wellDepth) * 100) + ((maqFeet / wellDepth) * 100) > 100
ROCK_TOP Elevation (in feet) of bedrock surface
D_R_TYPE AQ Type for Drift / Rock
interface
AA = AQ / AQ
MA
= MA / AQ
AM = AQ / MAQ
SPC_CPCITY Specific Capacity {TEST_RATE / TEST_DEPTH}
Only calculate if [TEST_METHD] = BAIL, PLUGR, or TSTPUM
DRIFT
AQUIFER PERCENT FIELDS (within Analysis Zone)
Qualifying confining unit: >= 5 feet CM or >= 10 feet PCM
Analysis Zone: from [SCREEN_TO] upward to
A) the bottom of a qualifying confining unit;
B) the SWL; or
C) the ground surface
FIELD Description
A_THICKNES Aquifer Thickness within Analysis Zone
A_PCT_AQ Percent AQ within Analysis Zone
A_PCT_MAQ Percent MAQ within Analysis Zone
A_PCT_PCM Percent PCM within Analysis Zone
A_PCT_CM Percent CM within Analysis Zone
A_PCT_NA Percent NA within Analysis Zone
A_HIT_SWL T = Analysis stopped because hit SWL
F = Analysis stopped because hit a qualifying confining unit
A_HIT_TOP [Data Problem Flag]
T = Analysis stopped because hit well elevation (surface)
A_HIT_ROCK [Data Problem Flag]
T = Analysis stopped because hit an “R” in AQTYPE
A_SC_LITH1 PRIMLITH code for dominant strata within screen zone
A_SC_LMOD1 LITHMOD code for dominant strata within screen zone
A_SC_LMAQ1 MAQTYPE code for dominant strata within screen zone
A_SC_LPCT1 Percent LITH1 for dominant strata within screen zone
A_SC_LITH2 PRIMLITH code for secondary strata within screen zone
A_SC_LMOD2 LITHMOD code for secondary strata within screen zone
A_SC_LMAQ1 MAQTYPE code for secondary strata within screen zone
A_SC_LPCT12 Percent LITH2 for secondary strata within screen zone
Check
if well point is within PLSS section
FIELD Description
WITHIN_SEC Y Yes within 1,000’ buffer around land survey section
N No, well is not within section buffer area
Calculated
values used in GWMAP Project for glacial deposits surfaces
FIELD Description
Drift Index Layers -Those layers that are flagged as aquifer layers then have the Drift Index calculated. The drift index is equal to three times the percentage of aquifer material, added to two times the percentage of marginal aquifer material, added to percentage of partial confining material. This sum is then divided by the percentage of representative aquifer material (((PCT_AQ_* x 3) + (PCT_MAQ_* x 2) + PCT_PCM_*)/PCT_*_Rep). The index has potential values between zero and three where zero is no drift material and where three is all drift material
DID Drift
Index for the entire drift
DI1 Drift
Index for Layer 1
DI2 Drift
Index for Layer 2
DI3 Drift
Index for Layer 3
DI4 Drift
Index for Layer 4
DI5 Drift
Index for Layer 5
DI6 Drift
Index for Layer 6
DI7 Drift
Index for Layer 7
DI8 Drift
Index for Layer 8
DI9 Drift
Index for Layer 9
DI10 Drift
Index for Layer 10
DI11 Drift
Index for Layer 11
DI12 Drift
Index for Layer 12
DI13 Drift
Index for Layer 13
DIAQ Drift
Index for the aquifer
DIAQ2
Trends
in the aquifer material within the well-The layers of the well are then compared to detect any trends
in the aquifer material within the well.
These are reported in two fields (Trend9 and Trend14). Trend9 represents detection of a change in
the Drift Index, from the surface down, of .9 or more, Trend14 represents a change
in the Drift Index of 1.4 or more. The
trends have six labels associated with them. An “Up” trend indicates an
increase in the drift index beyond the threshold (of .9 or 1.4) in every layer
as the well goes deeper, a “Down” trend is the same but with a decreasing
index. An “Upward” trend indicated that
there are increases in the drift index between layers that pass the threshold
in some, but not all layers. A
“Downward” trend is the counterpart to the “Upward” but with a decreasing drift
index. The “ZigZag”
label indicates that there are layers in the well between which the drift index
increases by more than the threshold and other layers where it decreases by
more than the threshold. The final label
is “None” which indicates that the Drift Index in the well does not increase or
decrease beyond the threshold between any of the layers. The counts of usable layers, along with the
number of times that the well had layers that passed each of the thresholds in
either direction, are also included in the dataset.
Trend9 General
trend when looking at change of at least .9 in the
Drift Index (described above)
Trend9_Up Number
of instances where an increase of at least .9 occurred in the Drift Index
between layers
Trend9_Dn Number
of instances where a decrease of at least .9 occurred in the Drift Index
between layers
Trend14
General trend when looking at change of at least 1.4 in the Drift
Index (described above)
Trend14_Up Number
of instances where an increase of at least 1.4 occurred in the Drift Index
between layers
Trend14_Dn Number
of instances where a decrease of at least 1.4 occurred in the Drift Index
between layers
Trend_All Number
of layers where there was a Drift Index calculated
SW_ELEV Static
Water Elevation calculated by subtracting the Static Water Level (SWL) field
from the DEM Elevation (ELEV_DEM) field.
LANDSYSTEM Values
LDSYSTEM Bedrock
Costal
Dunes
Ice-contact
outwash
Lacustrine Fine
Lacustrine Course
Lakes
Lodge
Till of Fine superaglacial drift
Proglacial outwash
Thin
drift over bedrock
Ice-marginal
fill
Landsys 0
= Bedrock, Lacustrine Fine, Thin drift over bedrock
1
= Lacustrine Course, Lodge Till of Fine superaglacial drift, Ice-marginal fill
2
= Costal Dunes, Ice-contact outwash, Proglacial
outwash
9 = Wells that did
not fall inside Landsys 0, 1, or 2
________________________________________________
Justin M. Booth, GISP
Remote Sensing and GIS Research and Outreach Services
Department of
(517) 432-0446
boothj@msu.edu